<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<html>
<head><title>Simple jsp page</title></head>
<body>
<sql:query var="rs" dataSource="db/testDb">
    select * from TEST_TABLE
</sql:query>
<c:forEach items="${rs.rows}" var="item">
    <div>
        ID: ${item.oid}<br/>
        Name: ${item.name}<br/>
        Parent: ${item.parent}<br/>
    </div>
</c:forEach>
</body>
</html>